/opt/module/sqoop/bin/sqoop export \
--connect 'jdbc:mysql://node101:3306/mall_report?useUnicode=true&characterEncoding=UTF-8' \
--username root \
--password 123456 \
--table log_page_view_province_report \
--update-key 'province_id, province_name' \
--export-dir /user/spark/warehouse/mall_ads/ads_log_page_view_province_report/dt=2025-04-09 \
--input-fields-terminated-by "\001" \
--update-mode allowinsert \
--num-mappers 1 \
--input-null-non-string '\\N' \
--input-null-string '\\N'

sqoop export \
--connect 'jdbc:mysql://node101:3306/mall_report?useUnicode=true&characterEncoding=UTF-8' \
--username root \
--password 123456 \
--table log_page_view_channel_report \
--update-key 'channel' \
--export-dir 'hdfs://node101:8020/user/spark/warehouse/mall_ads/ads_log_page_view_channel_report/dt=2025-04-09' \
--input-fields-terminated-by '\001' \
--update-mode allowinsert \
--num-mappers 1 \
--input-null-non-string '\\N' \
--input-null-string '\\N'